IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[InsertDistrito]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[InsertDistrito]
GO

CREATE PROCEDURE [dbo].[InsertDistrito]
(
	@IdDistrito int,
	@IdProvincia int,
	@Nombre varchar(150),
	@Flete money,
	@Estado bit
)
AS
BEGIN
	SET NOCOUNT ON

	INSERT INTO [Distrito] ([IdDistrito], [IdProvincia], [Nombre], [Flete], [Estado]) 
	VALUES (@IdDistrito, @IdProvincia, @Nombre, @Flete, @Estado)

	SET NOCOUNT OFF
END

GO
